enq: TX - contention
Enqueue wait. Transaction.
Additional Informationβ
An enqueue is a wait for a resource held by another.
enq: TX - contention is a transaction related enqueue. This can be another session waiting on row level locks to be released by either a commit or rollback. The object in question may be a table or an index.
How to reduce this waitβ
Examine application logic to check for multiple updated to the records in the same block.
ASH reports will not always show the problem SQL, as the locking session may be very brief and not be active when the stats are gathered. These cases are difficult to diagnose.
Ali Kaparβs blog βenq tx β row lock contention and p1 value analyzeβ gives techniques to help diagnose the locking issues.
On ORA-600.pl, βTHE CURIOUS CASE OF ENQ: TX β ROW LOCK CONTENTIONβ shows that a case, enq: TX - contention was caused by introduction of network latency after a migration to a remote location.
Additional Linksβ
Oracle Docs - Oracle Enqueue Names
Ali Kaparβs blog - enq tx β row lock contention and p1 value analyze
ORA-600.pl - THE CURIOUS CASE OF ENQ: TX β ROW LOCK CONTENTION
Search onlineβ
If this article doesn't have the information you need you can try searching online. Remember, you can contribute suggestions to this page.